Tabela PatogenInstance

Definicja tabeli PatogenInstance

Name

PatogenInstance

Code

PatogenInstance

Comment

Wystapienia patogenów dla zakazenia


Lista kolumn tabeli PatogenInstance

Name

Code

PatogenInstanceID

PatogenInstanceID

InfectionID

InfectionID

PatogenID

PatogenID

MaterialID

MaterialID

InfectionTypeID

InfectionTypeID

PerfServiceID

PerfServiceID

CollectionDT

CollectionDT

Colonization

Colonization

AdditionalInfo

AdditionalInfo

InsertDate

InsertDate

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

AuthPersonID

AuthPersonID

AuthComment

AuthComment

IsCollected

IsCollected

APDrugResistance

APDrugResistance

WeeksBeforeHospitalization

WeeksBeforeHospitalization

APSourceHospitalID

APSourceHospitalID

WeeksBeforeHospitalizationDT

WeeksBeforeHospitalizationDT

PatogenClassID

PatogenClassID

APClassSourceHospitalID

APClassSourceHospitalID

PatogenColorID

PatogenColorID


Kolumna PatogenInstanceID tabeli PatogenInstance

Definicja kolumny PatogenInstanceID tabeli PatogenInstance

Name

PatogenInstanceID

Code

PatogenInstanceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InfectionID tabeli PatogenInstance

Definicja kolumny InfectionID tabeli PatogenInstance

Name

InfectionID

Code

InfectionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatogenID tabeli PatogenInstance

Definicja kolumny PatogenID tabeli PatogenInstance

Name

PatogenID

Code

PatogenID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MaterialID tabeli PatogenInstance

Definicja kolumny MaterialID tabeli PatogenInstance

Name

MaterialID

Code

MaterialID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InfectionTypeID tabeli PatogenInstance

Definicja kolumny InfectionTypeID tabeli PatogenInstance

Name

InfectionTypeID

Code

InfectionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfServiceID tabeli PatogenInstance

Definicja kolumny PerfServiceID tabeli PatogenInstance

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CollectionDT tabeli PatogenInstance

Definicja kolumny CollectionDT tabeli PatogenInstance

Name

CollectionDT

Code

CollectionDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Colonization tabeli PatogenInstance

Definicja kolumny Colonization tabeli PatogenInstance

Name

Colonization

Code

Colonization

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna AdditionalInfo tabeli PatogenInstance

Definicja kolumny AdditionalInfo tabeli PatogenInstance

Name

AdditionalInfo

Code

AdditionalInfo

Data Type

VARCHAR2(1024)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli PatogenInstance

Definicja kolumny InsertDate tabeli PatogenInstance

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertingPerson tabeli PatogenInstance

Definicja kolumny InsertingPerson tabeli PatogenInstance

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna LastModifiedDT tabeli PatogenInstance

Definicja kolumny LastModifiedDT tabeli PatogenInstance

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli PatogenInstance

Definicja kolumny LastModifiedPerson tabeli PatogenInstance

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AuthPersonID tabeli PatogenInstance

Definicja kolumny AuthPersonID tabeli PatogenInstance

Name

AuthPersonID

Code

AuthPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

Idenfikator osoby autoryzujacej patogen alarmowy


Kolumna AuthComment tabeli PatogenInstance

Definicja kolumny AuthComment tabeli PatogenInstance

Name

AuthComment

Code

AuthComment

Data Type

VARCHAR2(100)

Mandatory

No

Comment

Komentarz osoby autoryzujacej patogen alarmowy


Kolumna IsCollected tabeli PatogenInstance

Definicja kolumny IsCollected tabeli PatogenInstance

Name

IsCollected

Code

IsCollected

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy material pobrano w 72 godziny od przyjecia


Kolumna APDrugResistance tabeli PatogenInstance

Definicja kolumny APDrugResistance tabeli PatogenInstance

Name

APDrugResistance

Code

APDrugResistance

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Odpornosc patogenu na leki


Kolumna WeeksBeforeHospitalization tabeli PatogenInstance

Definicja kolumny WeeksBeforeHospitalization tabeli PatogenInstance

Name

WeeksBeforeHospitalization

Code

WeeksBeforeHospitalization

Data Type

NUMBER(5)

Mandatory

No

Comment

Czy byla wczesniejsza hospitalizacja


Kolumna APSourceHospitalID tabeli PatogenInstance

Definicja kolumny APSourceHospitalID tabeli PatogenInstance

Name

APSourceHospitalID

Code

APSourceHospitalID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki zewnetrznej w przypadku wystapienia wczesniejszej Hospitalizacji


Kolumna WeeksBeforeHospitalizationDT tabeli PatogenInstance

Definicja kolumny WeeksBeforeHospitalizationDT tabeli PatogenInstance

Name

WeeksBeforeHospitalizationDT

Code

WeeksBeforeHospitalizationDT

Data Type

DATE

Mandatory

No

Comment

Data wczesniejszej hospitalizacji


Kolumna PatogenClassID tabeli PatogenInstance

Definicja kolumny PatogenClassID tabeli PatogenInstance

Name

PatogenClassID

Code

PatogenClassID

Data Type

NUMBER(10)

Mandatory

No

Comment

Zródlo pochodzenia drobnoustroju alarmowego


Kolumna APClassSourceHospitalID tabeli PatogenInstance

Definicja kolumny APClassSourceHospitalID tabeli PatogenInstance

Name

APClassSourceHospitalID

Code

APClassSourceHospitalID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki zewnetrznej w przypadku gdy zródlo pochodzenia drobnoustroju alarmowego jest zewnetrzne


Kolumna PatogenColorID tabeli PatogenInstance

Definicja kolumny PatogenColorID tabeli PatogenInstance

Name

PatogenColorID

Code

PatogenColorID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID definicji kolorów


Lista kluczy tabeli PatogenInstance

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PatogenInstance

Definicja klucza Identifier_1 tabeli PatogenInstance

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment